﻿CREATE TABLE [flcr].[CONTRACT_DETAIL_PROPERTY] (
    [CONTRACT_DETAIL_PROP_ID]      INT           NOT NULL,
    [AUDIT_USER]                   VARCHAR (100) NOT NULL,
    [AUDIT_DTTM]                   DATETIME      NOT NULL,
    [AUDIT_DTTM_TZ]                INT           NOT NULL,
    [AUDIT_MOD_USER]               VARCHAR (100) NOT NULL,
    [AUDIT_MOD_DTTM]               DATETIME      NOT NULL,
    [AUDIT_MOD_DTTM_TZ]            INT           NOT NULL,
    [BUILTIN]                      BIT           NOT NULL,
    [ACTIVE_FLG]                   BIT           NOT NULL,
    [SORT_ORDER]                   INT           NOT NULL,
    [CONTRACT_TYPE]                INT           NOT NULL,
    [PNAME_CONTRACT_PROP_TYPE_ID]  INT           NOT NULL,
    [PVALUE_CONTRACT_PROP_TYPE_ID] INT           NOT NULL,
    [PARENT_ID]                    INT           NULL
);

